drop table jms_dwd.dwd_nosign_waybill;
CREATE TABLE jms_dwd.dwd_nosign_waybill (
  input_time date NULL COMMENT "录入时间",
  waybill_no varchar(50) NULL COMMENT "运单编号",
  terminal_dispatch_code varchar(50) NULL COMMENT "三段码",
  package_name varchar(160) NULL COMMENT "集包地",
  receiver_name varchar(350) NULL COMMENT "收件人姓名",
  receiver_mobile_phone varchar(380) NULL COMMENT "",
  receiver_address varchar(880) NULL COMMENT "收件人地址(多字段concat)",
  sender_name varchar(350) NULL COMMENT "寄件人姓名",
  sender_mobile_phone varchar(380) NULL COMMENT "",
  sender_address varchar(880) NULL COMMENT "寄件人地址(多字段concat)",
  remarks varchar(880) NULL COMMENT "备注",
  delivery_time datetime NULL COMMENT "寄件时间",
  pre_3_receiver_mobile varchar(3) NULL COMMENT "收件人手机前三位",
  pre_3_sender_mobile varchar(3) NULL COMMENT "发件人手机前三位",
  last_4_sender_mobile varchar(4) NULL COMMENT "发件人手机后四位",
  last_4_receiver_mobile varchar(4) NULL COMMENT "收件人手机后四位"
DUPLICATE KEY(input_time, waybill_no)
COMMENT "未签收运单明细表"
DISTRIBUTED BY HASH(waybill_no) BUCKETS 100
PROPERTIES (
"replication_num" = "3",
"bloom_filter_columns" = "waybill_no",
"in_memory" = "false",
"storage_format" = "V2"
);